<?php
/**
 *	@name		商品拍卖
 *	@author		Jeffery
 *	@qq			1017756891
 *	@email		1017756891@qq.com
 *	@website	http://www.iweitao.net
**/


if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}

$sql = <<< SQL

DROP TABLE IF EXISTS `pre_paipai_buy`;
CREATE TABLE IF NOT EXISTS `pre_paipai_buy` (
  `orderid` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `gid` int(10) NOT NULL,
  `tid` int(10) NOT NULL,
  `username` char(15) NOT NULL,
  `price` char(10) NOT NULL,
  `time` char(15) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`orderid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `pre_paipai_goods`;
CREATE TABLE IF NOT EXISTS `pre_paipai_goods` (
  `gid` int(10) NOT NULL AUTO_INCREMENT,
  `tid` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `username` char(15) NOT NULL,
  `type` char(10) NOT NULL,
  `made` char(10) NOT NULL,
  `title` char(15) NOT NULL,
  `price` char(10) NOT NULL,
  `add_price` char(10) NOT NULL,
  `send` char(15) NOT NULL,
  `focus` char(255) NOT NULL,
  `focus2` char(255) NOT NULL,
  `focus3` char(255) NOT NULL,
  `focus4` char(255) NOT NULL,
  `focus5` char(255) NOT NULL,
  `data_start` char(20) NOT NULL,
  `data_end` char(20) NOT NULL,
  `identify` char(20)  NOT NULL,
  `status` int(1) NOT NULL,
  `freeze` int(1) NOT NULL,
  PRIMARY KEY (`gid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

SQL;

runquery($sql);
$finish = TRUE;
?>